﻿CREATE TABLE [dbo].[TransactionSet]
(
[TransactionSetIdentifierCode] [nvarchar] (3) NULL,
[TransactionSetControlNumber] [nvarchar] (9) NULL,
[HierarchicalStructureCode] [nvarchar] (4) NULL,
[TransactionSetPurposeCode] [nvarchar] (2) NULL,
[OriginatorApplicationTransactionIdentifier] [nvarchar] (30) NULL,
[TransactionSetCreationDate] [nvarchar] (8) NULL,
[TransactionSetCreationTime] [nvarchar] (8) NULL,
[ClaimOrEncounterIdentifier] [nvarchar] (2) NULL,
[ReferenceIdentificationQualifier] [nvarchar] (3) NULL,
[TransmissionTypeCode] [nvarchar] (30) NULL,
[SubmitterEntityIdentifierCode] [nvarchar] (3) NULL,
[SubmitterEntityTypeQualifier] [nvarchar] (1) NULL,
[SubmitterLastOrOrganizationName] [nvarchar] (35) NULL,
[SubmitterFirstName] [nvarchar] (25) NULL,
[SubmitterMiddleName] [nvarchar] (25) NULL,
[SubmitterIdentificationCodeQualifier] [nvarchar] (2) NULL,
[SubmitterIdentifier] [nvarchar] (80) NULL,
[SubmitterContactFunctionCode] [nvarchar] (2) NULL,
[SubmitterContactName] [nvarchar] (60) NULL,
[SubmitterCommunicationNumberQualifier1] [nvarchar] (2) NULL,
[SubmitterCommunicationNumber1] [nvarchar] (80) NULL,
[SubmitterCommunicationNumberQualifier2] [nvarchar] (2) NULL,
[SubmitterCommunicationNumber2] [nvarchar] (80) NULL,
[SubmitterCommunicationNumberQualifier3] [nvarchar] (2) NULL,
[SubmitterCommunicationNumber3] [nvarchar] (80) NULL,
[ReceiverEntityIdentifierCode] [nvarchar] (3) NULL,
[ReceiverEntityTypeQualifier] [nvarchar] (1) NULL,
[ReceiverLastOrOrganizationName] [nvarchar] (35) NULL,
[ReceiverIdentificationNumber] [nvarchar] (2) NULL,
[ReceiverPrimaryIdentifier] [nvarchar] (80) NULL,
[EDIMessageType] [nvarchar] (50) NULL,
[DateProcessed] [datetime] NULL,
[GroupControlNumber] [nvarchar] (9) NULL,
[InterchangeControlNumber] [nvarchar] (9) NULL,
[GroupIDKey] [int] NULL,
[TransactionSetIDKey] [int] NOT NULL IDENTITY(1, 1),
[InterchangeIDKey] [int] NULL,
[BTSMessageID] [nvarchar] (100) NULL,
[BTSInterchangeID] [nvarchar] (100) NULL
) ON [PRIMARY]


